SELECT        TOP (100) PERCENT dbo.UPR30300.EMPLOYID AS [Employee ID], MIN(dbo.UPR00100.LASTNAME) AS [Last Name], MIN(dbo.UPR00100.FRSTNAME) AS [First Name], MIN(dbo.UPR00100.MIDLNAME) 
                         AS [Middle Name], MIN(dbo.UPR00100.EMPLOYMENTTYPE) AS [Employment Type], SUM(dbo.UPR30300.UNTSTOPY) AS [Hours Worked]
FROM            dbo.UPR30300 INNER JOIN
                         dbo.UPR00100 ON dbo.UPR30300.EMPLOYID = dbo.UPR00100.EMPLOYID
WHERE        (dbo.UPR30300.PYRLRTYP = 1) AND (dbo.UPR30300.CHEKDATE >= CONVERT(DATETIME, '2024-01-01 00:00:00', 102)) AND (dbo.UPR30300.CHEKDATE <= CONVERT(DATETIME, '2024-02-01 00:00:00', 102))
GROUP BY dbo.UPR30300.EMPLOYID
